��v(��y`�>?f"O
�/�	�9eI�K�LO~S[�U��\WK_	th5�n�}q�R��<�w	�-�&
j�h�-1��9�o�Ħ����.��%,����
/01 Add Database to Picklist
    Add a database file from another directory or with an
extension other than the current Default Database Extension to
the left window of available databases.                                
                                                             
    The added database file is inserted at the top of the pick-
list in the left window of available database files.
                                      
/02 Add Expression to Picklist / Edit Expression
    Add a valid Expression to the left window of available
Fields/Expressions. The Expression may be based on a Field from
the current or from a related database.

    If the Expression is a field from a related database, it
must be preceeded by the Alias of the related database and an
arrow, as in:   CUSTOMER->Name.
Other Examples: CDOW(StartDate), CMONTH(StartDate).
    UDFs from User libraries or Modules linked into BroPlus can
be used when specifying an expression.
    A custom column heading and display width for the new ex-
pression may be entered simultaneously.

    The added expression is inserted at the top of the picklist
in the left window.  To edit an already added expression, move
the highlight bar over the expression in the Fields Selection
Screen, and press <Alt-E>.
/03 Add Index File To Picklist
    Add an index file from another directory or with an exten-
sion other than the Default Index File Extension to the left
window of available databases.                          
                                                             
    The added index file is inserted at the top of the pick-
list in the left window of available database files.
                                                            
/04 Alias Name
   The Database menu option "Alias Name" allows users to assign
a non-default Alias name to a database.

When opening a database, it is automatically given the database
root name for use as Alias name. There are a few situations
where a different Alias name is useful or required:

1.Two databases have the same root name, but are located in
  different directories, or have a different file extension. If
  you wish to open both databases, you need to assign a custom
  Alias name to one of the two files.

2.You wish to open the same database in more than one area,
  e.g. for simultaneous viewing of two different database seg-
  ments in Split screen mode. Simply select the database from
  the Database Selection screen, assign a custom Alias to the
  database, then select this database again, and a second
  instance of this database is opened, with the default
  database root name as the Alias.

  WARNING: Editing of data while a database is open in more
  than one area is strongly discouraged, since it might lead to
  unpredictable results.

3.The database root name contains characters which are not
  "legal" in a Clipper Alias name. A valid Clipper Alias may
  contain only the characters "A"..."Z", "0"..."9", and "_"
  (Underscore), and has to begin with a letter. One-letter
  Aliases "A"..."J" and "M" are not allowed. If you try to open
  a database with root name that is not a "legal" Clipper
  Alias, BroPlus will alert you and let you enter an alter-
  native Alias name.

4.An Index or Tag belonging to the current database has an
  aliased key expression, but the Alias in the key expression
  differs from the database root name. In order to successfully
  open this index, you need to assign to the database the Alias
  used in the key expression.

Alias names are saved in View files as attributes of the select
areas.
/05 Append From
    APPEND FROM is a Pulldown Menu item on the "Command" Main
Menu option. It allows to Append Data from another database or
text file to the current database, for/while a condition/range.
If the source file is a database, testing is provided to ensure
that the source file is NOT in use.

Parameter entry fields:

    - FORMAT: Press <Enter> to select between formats "DBF",
              "SDF", or "DELIMITED", or press <Down arrow> to
              confirm the current Format.
              If "DELIMITED" is selected, enter the character
              used as delimiter.
              The default delimiter character is a '"'.
    - FIELDS: Press <Enter> to select between "All Fields" and
              "Current Fields", or press <Down arrow> to con-
              firm the current Fields setting.
              If "All Fields" is selected, APPEND FROM appends
              the data from the source database or text file to
              ALL fields of the target database.
                 If "Current Fields" is selected, APPEND FROM
              appends the data from the source database or text
              file to only those FIELDS that are specified in
              the current list of fields in the Fields Select-
              ion Screen. Any expressions that may be contained
              in this list are ignored by the APPEND FROM
              process.
    - FROM:   Specify the path and file name of the source file
              to be APPENDed FROM. If the Format selected is
              "DBF", on the file name entry field a Picklist of
              "*.DBF" files in the with "path" specified direc-
              tory pops up. If the selected Format is "SDF" or
              "DELIMITED", a Picklist of "*.TXT" files is
              offered. Select an item from the Picklist, or
              press <Esc> on the Picklist and enter the source
              file name into the field. 
    - SCOPE:  Press <Enter> to select between "ALL", "NEXT",
              and "REST", or press <Down arrow> to confirm the
              current scope. 
              If "ALL" (default) is chosen processing starts at
              top of file unless a "WHILE" expression is ent-
              ered.
              If "NEXT" or "REST" is chosen, or "ALL" with a
              "WHILE" expression, processing starts at the
              current record.
              If "NEXT" is selected, enter the number of re-
              cords to process starting at the current record.
              If "REST" is selected, all records from the cur-
              rent record until end of file are processed.
    - WHILE:  A "WHILE" clause usually requires an index to be
              in control. Enter a logical expression, and pro-
              cessing will continue as long as the expression
              evaluates to TRUE. Example: "AGE < 65".
              If a Range is specified for the current Browse
              Window, the beginning and ending values of the
              Range are automatically translated into a "WHILE"
              expression and offered as default.
    - FOR:    Enter a conditional expression, e.g.:
              ZIP = "90064". Only records meeting the "FOR"
              condition are included in the processing.
              If a Filter condition is specified for the cur-
              rent Browse Window, the Filter expression is
              automatically offered as default for the "FOR"
              condition.

FOR and WHILE clauses: The <F4> key can be pressed while on
    the entry field, to display a picklist of fields from the
    current database. The expression is validated, invalid
    entry is recognized and rejected.

Note: If the FORMAT for the APPEND FROM command is "SDF" or
"DELIMITED", any SCOPE, WHILE, or FOR conditions are ignored by
the APPEND FROM process.
/06 Append Record
    The Append Record window may be accessed from the Record
Main Menu option, or from the Browse Screen by pressing <Ins>.

    The Append Record window provides full screen data entry to
add a new record to the database. The window looks exactly like
the Record Edit window, except all fields are empty. If the
database has more fields than screen rows are available, use
the <PgDn> and <PgUp> keys to access fields on the next or pre-
vious page of fields, <Ctrl-PgUp>/<Ctrl-PgDn> to access the
first and last page of fields.
    When you are finished entering data, press the <F10> key to
save the data instantly, or press the <Esc> key and confirm or
cancel Saving of the Data on the Prompt.

Network considerations: NO appending and locking of the new
record is performed until Saving of the entered data is
confirmed.

Note: Appending of data is also available from within the
Browse Window by pressing <Down arrow> from the last logical
record of a database (Append mode) and entering data in a field
of the new record.
/07 AreaSet
    The Pulldown Menu choices in the Main Menu option "AreaSet"
allow customization of specific aspects of the Browse Screen
for the current database. The following Menu choices are
offered:
    - Range & Filter: Specify a Top and a Bottom Value to limit
      the Browse Window display to a Range of data rows
      (BROWSE WHILE). Specify a conditional expression to dis-
      play only data rows with matching data (BROWSE FOR).

    - Relation: Display the Relations Window to view, add, mod-
      ify or delete relations set between open databases. At
      least two databases must be open for this menu option to
      be available.

    - Color Condition: Specify a conditional expression based
      on the value of a database field, e.g. "AGE > 65". All
      Browse Rows in the Browse Window containing values meet-
      ing the condition will be displayed highlighted in a dif-
      ferent color than the Standard Browse Color.

    - Incremental Seek: Toggle the ability to AutoSeek (Seek
      while you type) while in the Browse Window. An Index File
      with a Character Type Key Expression must be in control
      for Incremental Seek to be available. The characters
      entered are displayed on the bottom status bar of the
      Browse Screen. While in Incremental Seek Mode, use the
      <BackSpace> key for "Decremental" Seek, <Ctrl-BackSpace>
      to clear the Seek String.

    - Memo Width: Specify the Memo Display Width for Memo
      Fields of the current database, to allow proper alignment
      of text lines when viewing or printing Memo Fields.

    - SIx Driver Memo Pack: Allows packing of an FPT or SMT
      memo file to regain all unused space. A custom Memo pack
      size can be specified. (SIx Driver only)

    - FlexFile Link: Optionally specify the Name of a Flex file
      to be linked to the current Database.
      (FlexFile API interface only)

    - RYO Index Link: Optionally specify a "Roll Your Own"
      Index or Tag name to Add / Drop individual Keys to / from
      (SIX Driver only).

    - Next / Previous Select Area: Rotate to the Browse Screen
      for the "Next" or "Previous" Select Area as defined by
      the order of open databases in the right window of the
      Database Selection Screen.

    - Next Index Order: Refresh the current Browse Screen, but
      give control to the "Next" Index below the currently con-
      trolling index, as defined by the order of indexes/tags
      in the Tag Selection/Information window (Ctrl-F3). The
      current row in the Browse Window will remain highlighted,
      but the data rows above and below it will refresh,
      reflecting the new index Order.

    - Next / Previous Window: If the Split screen option is
      selected (Shift-F10), move from one window to the other
      with this menu option, or use the Tab / Shift-Tab keys
      while in a Browse window.

    - Restore View: Reinstate View from a previously saved View
      file.

    - Save Current View: Save all currently defined Browse
      Screens including Open Database Files, Area Drivers,
      Current Database, Open Index Files, Controlling Index,
      Current Tag, Field/Expression Selections, Filter & Range,
      Relations, Color Condition, Lock, Column Options, Memo
      Width, FlexFile Link, to a View File named by you.
/08 Average
    SUM/AVERAGE is a Pulldown Menu item on the "Command" Main
Menu option. It allows to calculate the Average of a numeric
field or a numeric expression based on fields from the current
database, for/while a condition/range.

Parameter entry fields:

    - Field/Expression to SUM/AVERAGE: A Picklist of Fields
              from the current database pops up. Select a nume-
              ric field from the list and use the field as is,
              or build a numeric expression to be AVERAGEd.
              While in the Field/Expression entry field, the
              <F4> key can be pressed to display the fields
              picklist again. The expression is validated, only
              numeric expressions are accepted.
    - SCOPE:  Press <Enter> to select between "ALL", "NEXT",
              and "REST", or press <Down arrow> to confirm the
              current scope. 
              If "ALL" (default) is chosen processing starts at
              top of file unless a "WHILE" expression is ent-
              ered.
              If "NEXT" or "REST" is chosen, or "ALL" with a
              "WHILE" expression, processing starts at the
              current record.
              If "NEXT" is selected, enter the number of re-
              cords to process starting at the current record.
              If "REST" is selected, all records from the cur-
              rent record until end of file are processed.
    - WHILE:  A "WHILE" clause usually requires an index to be
              in control. Enter a logical expression, and pro-
              cessing will continue as long as the expression
              evaluates to TRUE. Example: "AGE < 65".
              If a Range is specified for the current Browse
              Window, the beginning and ending values of the
              Range are automatically translated into a "WHILE"
              expression and offered as default.
    - FOR:    Enter a conditional expression, e.g.:
              ZIP = "90064". Only records meeting the "FOR"
              condition are included in the processing.
              If a Filter condition is specified for the cur-
              rent Browse Window, the Filter expression is
              automatically offered as default for the "FOR"
              condition.

FOR and WHILE clauses: The <F4> key can be pressed while on
    the entry field, to display a picklist of fields from the
    current database. The expression is validated, invalid
    entry is recognized and rejected.
/09 Browse Window
    The Browse Window allows browsing of the Field Selection
for the current database. The database name and, if selected,
the controlling index file name are displayed in the center of
the Browse Window's top frame. The current directory is shown
on the left side of the bottom status bar. Status information
like record number, number of Locked fields, Softseek status,
Open mode, and Deleted flag are shown just below the Browse
Window's top frame.
    The core of the Browse Window are the data rows and col-
umns, with a heading on top of each column. The entire row re-
presenting the current database record is highlighted, with one
cell's color standing out; this is where the actual Browse Cur-
sor is located.
    To move the Browse Cursor around within the Browse Window
the following keystrokes are available:

  -.. one column left    Ctrl - -  screen one column left
  -.. one column right   Ctrl - -  screen one column right
  ... one row up         Alt-T..... top of Browse Window
  ... one row down       Alt-B..... bottom of Browse Window
  PgUp one page up        Ctrl-PgUp  top of file
  PgDn one page down      Ctrl-PgDn  bottom of file

       Home........... leftmost column in the window
       End............ rightmost column in the window
       Ctrl-Home...... first column of current field selection
       Ctrl-End....... last column of current field selection
       Ctrl-PgDn + .. append mode

Other keystrokes available from within the Browse Window are:

  <F1> to <F9>........ Access Main Menu options
  <Alt-F1>............ Expression Evaluator
  <Ctrl-F1>........... Calculator
  <Alt-F2>............ Database Selection
  <Alt-F3>............ Index File Selection
  <Ctrl-F3>........... Tag Selection/Information
  <Shift-F3>.......... Index ScopeTop/Bottom (SIx/Comix only)
  <Alt-F4>............ Field / Expression Selection
  <Shift-F4>.......... Copy current Field to Clipboard
  <Ctrl-F4>........... Paste last copied item to current Field
  <Shift-F5>.......... Cut/Delete current Browse column
  <Ctrl-F5>........... Paste last deleted Browse column
  <Alt-F5>............ Insert column before curr. Browse column
  <Shift-F7>.......... Copy current Record to Clipboard
  <Ctrl-F7>........... Paste last copied item to current Record
  <Alt-F7>............ View/edit Clipboard, paste from Clipbd
  <F10>............... Toggle between 25|43|50 lines per screen
  <Shift-F10>......... Split Screen / Zoom
  <Ctrl-F10>.......... Move Screen Border
  <Enter>............. Edit the field under the Browse cursor
  <Esc>............... Exit BroPlus
  <Ins>............... Append Record
  <Del>............... Delete/Recall Record
  <Alt-BackSpace>..... Erase Memo data under the Browse Cursor
  <Ctrl-Ins>.......... Add Key to specific "RYO" Index (SIx)
  <Ctrl-Del>.......... Drop Key from curr. "RYO" Index (SIx)
  <Alt-A>............. Record View/Edit - All Fields
  <Alt-C>............. Color condition
  <Alt-E>............. Record View/Edit - Selected Fields
  <Alt-F>............. Range/Filter
  <Alt-G>............. GOTO
  <Alt-H>............. Column Options (Heading/Width etc.)
  <Alt-I>............. Toggle Incremental Seek
  <Alt-J>............. SKIP
  <Alt-L>............. Lock # of fields
  <Alt-N>............. Rotate to Browse Window for "Next" Area
  <Alt-Minus>......... Rotate to Browse Window for "Prev." Area
  <Alt-O>............. Rotate controlling index Order & refresh
  <Alt-P>............. Toggle Index Preselection
  <Alt-Q>............. Toggle Softseek status
  <Alt-R>............. Relations
  <Alt-S>............. SEEK
  <Alt-U>............. LOCATE
  <Alt-V>............. Restore View
  <Alt-W>............. Save current View
  <Alt-X>............. Toggle EXCLUSIVE / SHARED
  <Alt-Y>............. Change directory
  <Alt-Z>............. Shell to DOS
  <Alt-1> to <Alt-7>.. Access Browse Windows for areas 1 to 7
/10 Cell/Row/Column Edit
    In the GlobalSet Menu options, you can specify whether to
enable CELL EDIT, ROW EDIT, or COLUMN EDIT while working inside
the Browse Window. After Editing of a Cell in the Browse Window
and completing the Edit with <Enter>:

CELL EDIT:   The highlight bar in the Browse Window will remain
             on the same cell.
ROW EDIT:    The highlight bar will proceed to the cell to the
             right on the same data row.
COLUMN EDIT: The highlight bar will proceed to the cell below
             on the same data column.
/11 Change Directory
    The Change Directory option can be accessed from the Data-
base and Index Main Menu options, or by pressing <Alt-Y> from
the Browse Window, the Database Selection Screen, the Index
Selection Screen or the Field Selection Screen.

    To directly enter the target drive/directory press "N" on
the "View Directory List" prompt. Enter the complete path of
the target directory, e.g. "C:\ACCT\DATA\", or enter the drive
letter followed by a colon, e.g. "F:", to access the last
selected directory on the target drive.

    To select a directory from a list of directories press "Y"
on the "View Directory List" prompt, then enter a valid drive
letter. The first time a target drive letter is entered, the
specified drive needs to be scanned to create the directory
list. This takes a few seconds. After the initial scan, the
directory list pops up immediately every time the same drive
letter is specified.
/12 Clipboard View/Edit
    The Clipboard View/Edit window can be accessed from the
Record Main Menu options, or by pressing <Alt-F7> from the
Browse window.

    This option displays a window containing all Clipboard
items of the current BroPlus session in descending order, last
copied item first. Clipboard items can be added, deleted,
edited, and pasted from the Clipboard window. Data Rows or
Records are displayed as arrays. To view their content press
<Enter> on the {...} symbol. Other key strokes available from
the Clipboard window are:

  <Enter>..... Edit current item
  <Alt-M>..... Edit current item in MemoEdit type window
               (Useful for long character strings)
  <Del>....... Delete current item
  <Ins>....... Insert a new Clipboard item
  <Ctrl-F4>... Paste current Clipboard item into current Browse
               Field
  <Ctrl-F7>... Paste current Clipboard item into current Browse
               Row or Record

    BroPlus will inform you in case the type of the pasted item
does not match the target Field or Record.
/13 Color Condition
    The Color Condition Window may be accessed from the AreaSet
Main Menu option, or from the Browse Screen by pressing
<Alt-C>.

    Specify a conditional expression based on the value of
a database field, e.g. "AGE > 65". All Browse Rows in the
Browse Window containing values meeting the condition will be
displayed highlighted in a different color than the Standard
Browse Color.

    The <F4> key can be pressed while on the Color Condition
entry field, to display a picklist of fields from the current
database. The expression is validated, invalid entry is recog-
nized and rejected.
/14 Column Options
    The Column Options entry screen may be accessed from the
AreaSet Main Menu option, or from the Browse Screen by pressing
<Alt-H>.

    Column Heading: By default, the database field name as de-
fined in the database structure is displayed as Column Heading
in the Browse Window. A more meaningful and readable Column
Heading for database fields and expressions can be entered in
this window. For 2 or more line headings, insert a ";" in the
text where you want a line feed to occur.

    Likewise, the Column Display Width can be changed.
Warning: Numeric fields/expressions are treated exactly like
character type fields when their display width is shortened:
They are truncated from the right!

   GET Clauses to be used when editing the content of the field
in the current Browse Column: PICTURE, WHEN, VALID.

   PICTURE: Enter a picture template or function as documented
           in the Clipper manual, to be applied to data in the
           current Field during Editing.
           Examples: @!   display all characters in Upper Case
                     Y    display logical Data as "Y" or "N"
           Note: Under Clipper 5.2, the entry in the PICTURE
                 field is also used for formatting of the
                 Browse column while in Browse mode.
   WHEN:   Enter a logical expression to indicate the condition
           when a field should be editable. To exclude a field
           from Editing, simply enter: .F.
   VALID:  Enter a logical expression to be evaluated when ter-
           minating an Edit on the current field.
           Example: !empty( CUSTNAME )

   Press <F4> from the WHEN or VALID expression entry field for
a picklist of fields from the current database.
/15 Command Line Parameters
  Usage:  BRO [ [<dbfname> [<ntxname>]] | [/V [<viewname>]] ]
              [ /<rddname> ]  [ /M | /C ]
  where:  <dbfname>  is an optional database name
          <ntxname>  is an optional index file name
          /V         indicates intent to restore a view file
          <viewname> is the name of an optional, previously
                     saved view to be restored from disk
          /<rddname> forces use of a specific Database/Index
                     Driver, e.g. /DBFCDX
          /M         forces monochrome display,
          /C         forces color display if specified
/16 Command
    The Pulldown Menu choices in the Main Menu option "Command"
are mainly database commands that perform global processing on
the current database. If a Range/Filter is set up for the curr-
ent Browse Window, the FOR and WHILE clauses in the command pa-
rameter entry screens contain already the appropriate express-
ions for the Range and Filter condition. The following Pulldown
Menu choices are offered:

    - APPEND FROM: Append Data from another database or text
      file to the current database, for/while a condition /
      range.

    - COPY STRUCTURE: Copy the structure of the current data-
      base to another file.

    - COPY STRU EXTE: Create a structure extended database of
      the current database.

    - COPY TO: Copy data from the current database to another
      database or text file, for/while a condition/range.

    - COUNT: Count the number of records for/while a condition/
      range.

    - DELETE: Delete all records for/while a condition/range.

    - Label Form: Execute the Label Form command, specify any
      optional clauses.

    - LIST TO PRINT: List the Current Fields columnwise, or in
      One Page per Record, or list the content of a specified
      Memo Field, to the printer or to a text file, for/while a
      condition/range.

    - PACK: Pack the current database, recreate all it's curr-
      ently open index files.

    - RECALL: Recall all records for/while a condition/range.

    - REINDEX: Recreate all currently open index files of the
      current database.

    - REPLACE: Replace a specified field of the current data-
      base with an expression for/while a condition/range.

    - REPORT FORM: Execute the Report Form command, specify any
      optional clauses.

    - RUN: Shell out to DOS. To return to BroPlus type EXIT on
      the DOS Prompt.

    - SUM/AVERAGE: Calculate the sum and the average for a
      specified numeric database field or expression, for/while
      a condition/range.

    - ZAP: Zap the current database file, including all its
      currently open index files.

    - SWAP to DOS: Execute DOS programs with almost the same
      amount of memory available as for BroPlus itself. To
      return to BroPlus type EXIT on the DOS Prompt.
/17 Copy / Paste to / from Clipboard
    The Record Pulldown Menu contains 5 options for copying and
pasting fields and data rows / records:

    "Copy Field" copies the content of the current Browse cell
to the Clipboard. If the current cell is a Memo field or Flex-
File pointer field, the content of the data is copied, which
allows copying of arrays and other data types to the Clipboard.
    Shortcut key from the Browse window: <Shift-F4>

    "Paste Field" writes the content of the last copied Clip-
board item into the current Browse window cell. If the Global-
Set menu option "Protected Edit" is selected, you are prompted
to confirm or cancel before pasting. BroPlus will inform you in
case the data types don't match.
    Shortcut key from the Browse window: <Ctrl-F4>

    "Copy Record" copies the content of the current Browse win-
dow row to the Clipboard, and stores it as an array.
    Shortcut key from the Browse window: <Shift-F7>

    "Paste Record" writes the content of the last copied Clip-
board item into the current Browse window row. If the record
pointer is not positioned to EOF, you are prompted to confirm
or cancel before pasting.  BroPlus will inform you in case the
data types of the target record don't match the pasted item.
    Shortcut key from the Browse window: <Ctrl-F7>

    "View ClipBoard" displays a window containing all Clipboard
items of the current BroPlus session in descending order, last
copied item first. Clipboard items can be added, deleted,
edited, and pasted from the Clipboard window.
    Shortcut key from the Browse window: <Alt-F7>
/18 Copy Structure
    COPY STRUCTURE and COPY STRU EXTE are Pulldown Menu items
on the "Command" Main Menu option. They allow you to COPY the
STRUCTURE of the current database to another file, and to
CREATE an Extended Structure database of the current database,
e.g. for creation of a data dictionary.

Parameter entry fields:
    - Path:  Enter the path of the target file to be created.
    - File:  Enter the file name of the target file to be crea-
             ted. If no extension is specified, a ".DBF" exten-
             sion is appended. For a Picklist of files with a
             ".DBF" extension in the specified directory, press
             <Enter> on an empty file name field.
/19 Copy To
    COPY TO is a Pulldown Menu item on the "Command" Main Menu
option. It allows to COPY data from the current database TO an-
other database or text file, for/while a condition/range.
If the target file is a database, testing is provided to ensure
that the target file is NOT in use.

Parameter entry fields:

    - FORMAT: Press <Enter> to select between formats "DBF",
              "SDF", or "DELIMITED", or press <Down arrow> to
              confirm the current Format.
              If "DELIMITED" is selected, enter the character
              used as delimiter.
              The default delimiter character is a '"'.

    - FIELDS: Press <Enter> to select between "All Fields" and
              "Current Fields", or press <Down arrow> to con-
              firm the current Fields setting.

                If "All Fields" is selected, COPY TO copies ALL
              fields of the source database structure to the
              target database or text file.

                If "Current Fields" is selected, and the target
              FORMAT is "DBF", BroPlus creates the structure of
              the target database based on Name, Type, Width,
              and Decimal information retrieved from the Browse
              columns of the current TBrowse object. The data
              of the current Browse window, consisting of
              FIELDS and EXPRESSIONS as listed in the right
              window of the Field Selection Screen, are copied
              to the target database.
                In the target database, fields that are copied
              from a FIELD column in the source database will
              retain the same field name as in the source data-
              base, however the width of the field can differ
              from the width of the source field if it was
              modified in the Browse display.
                If the origin of a field in the target database
              is an EXPRESSION in the source Field Selection,
              the target field name will be _FIELD_xx, where
              'xx' is the ordinal number of the field in the
              target database structure, e.g. _FIELD_03.
                The standard implementation of the COPY TO
              command allows only FIELD names of the source
              database to be specified for the target database.
              The BroPlus variant of the COPY TO command goes
              beyond this limitation by also permitting
              EXPRESSIONS. This opens up a wide range of possi-
              bilities, e.g.: Structure Modifications that in-
              clude Data type conversions: STR( AMOUNT,7,2 ),
              or inclusion of data from a related database to
              the output database.

                If "Current Fields" is selected, and the target
              FORMAT is "SDF" or "DELIMITED", any Expressions
              contained in the current list of Fields in the
              Fields Selection Screen are ignored, and only
              database FIELDS from the source database that are
              contained in the Fields Selection list are COPYed
              to the target text file.

    - TO:     Specify the path and file name of the target file
              to be COPYed TO. If the Format selected is "DBF",
              on the file name entry field a Picklist of
              "*.DBF" files in the specified "path" directory
              pops up. If the selected Format is "SDF" or
              "DELIMITED", a Picklist of "*.TXT" files is
              offered. Select an item from the Picklist, or
              press <Esc> on the Picklist and enter the target
              file name into the field.

    - SCOPE:  Press <Enter> to select between "ALL", "NEXT",
              and "REST", or press <Down arrow> to confirm the
              current scope. 
              If "ALL" (default) is chosen processing starts at
              top of file unless a "WHILE" expression is ent-
              ered.
              If "NEXT" or "REST" is chosen, or "ALL" with a
              "WHILE" expression, processing starts at the
              current record.
              If "NEXT" is selected, enter the number of re-
              cords to process starting at the current record.
              If "REST" is selected, all records from the cur-
              rent record until end of file are processed.

    - WHILE:  A "WHILE" clause usually requires an index to be
              in control. Enter a logical expression, and pro-
              cessing will continue as long as the expression
              evaluates to TRUE. Example: "AGE < 65".
              If a Range is specified for the current Browse
              Window, the beginning and ending values of the
              Range are automatically translated into a "WHILE"
              expression and offered as default.
    - FOR:    Enter a conditional expression, e.g.:
              ZIP = "90064". Only records meeting the "FOR"
              condition are included in the processing.
              If a Filter condition is specified for the cur-
              rent Browse Window, the Filter expression is
              automatically offered as default for the "FOR"
              condition.

FOR and WHILE clauses: The <F4> key can be pressed while on
    the entry field, to display a picklist of fields from the
    current database. The expression is validated, invalid
    entry is recognized and rejected.
/20 Count Entry
    COUNT is a Pulldown Menu item on the "Command" Main Menu
option. It allows to COUNT the number of records of the current
database for/while a condition/range.

Parameter entry fields:

    - SCOPE:  Press <Enter> to select between "ALL", "NEXT",
              and "REST", or press <Down arrow> to confirm the
              current scope. 
              If "ALL" (default) is chosen processing starts at
              top of file unless a "WHILE" expression is ent-
              ered.
              If "NEXT" or "REST" is chosen, or "ALL" with a
              "WHILE" expression, processing starts at the
              current record.
              If "NEXT" is selected, enter the number of re-
              cords to process starting at the current record.
              If "REST" is selected, all records from the cur-
              rent record until end of file are processed.
    - WHILE:  A "WHILE" clause usually requires an index to be
              in control. Enter a logical expression, and pro-
              cessing will continue as long as the expression
              evaluates to TRUE. Example: "AGE < 65".
              If a Range is specified for the current Browse
              Window, the beginning and ending values of the
              Range are automatically translated into a "WHILE"
              expression and offered as default.
    - FOR:    Enter a conditional expression, e.g.:
              ZIP = "90064". Only records meeting the "FOR"
              condition are included in the processing.
              If a Filter condition is specified for the cur-
              rent Browse Window, the Filter expression is
              automatically offered as default for the "FOR"
              condition.

FOR and WHILE clauses: The <F4> key can be pressed while on
    the entry field, to display a picklist of fields from the
    current database. The expression is validated, invalid
    entry is recognized and rejected.
/21 Modify / Create Database
    The "Modify/Create Structure" Window can be accessed from
the Database and Fields Main Menu options, and from the Data-
base Selection Screen or the Fields Selection Screen by
pressing <Alt-M>. If a database was current when <Alt-M> was
pressed, the Structure of the current database is displayed in
the window. If no database was open or none was current, an
empty structure appears in the window.

    The following keystrokes are available from the "Structure"
window:

Standard cursor keys to move around in the structure:
 , , -, -, Home, End, PgUp, PgDn, Ctrl-PgUp, Ctrl-PgDn.

Structure Editing keys:

 <Ins>   Insert a field above the currently highlighted row.
 <Del>   Delete the field row under the lightbar.
        Down arrow from the last field row: Insert a field
         row at the end of the current structure.

To enter or change a Field NAME just type into the NAME cell.
To enter or change a Field TYPE type the first character of the
new TYPE: C, N, D, L, or M.
To enter or change a Field LENGTH or DECIMAL, just type in the
new number.

    To SAVE structure information the current database MUST be
open in EXCLUSIVE mode. Two keystroke options are available:

    <Alt-M>   Modify Structure of the current database and pre-
              serve data of fields with the same name as in the
              original structure. Write the data out to the
              original file or copy them to another file.

              If only field NAMES were changed, no fields dele-
              ted or inserted, and all TYPE, LENGTH, and
              DECIMAL information remained the same: Rewrite
              the database HEADER with the New Field Names,
              but leave the database DATA part untouched.

    <Alt-E>   Create an Empty Structure Database from the curr-
              ent structure information.

Other key strokes available from the structure window:

    <Alt-P>   Print current structure information to the
              printer or to a text file. If the text file name
              you specify exists already: Overwrite the file,
              Append to the file, or Cancel the operation.

    <Alt-X>   toggle Open Mode of the current database:
              EXCLUSIVE or SHARED.

    <F10>     Toggle display mode between 25|43|50 lines per
              screen.

    <Esc>     Return to the previous Screen.
/22 Create Index File (DBFNTX/DBFNDX, Clipper 5.01)
    This window can be accessed from the Index Main Menu option
or from the Index File Selection Screen by pressing <Alt-M>.
It is recommended that the current database be opened in
EXCLUSIVE mode for creation of an index file.

    If an index file is in control, this file's path, name, key
expression and unique attribute are offered as defaults in the
index parameter entry fields.

    If no index file is in control, or no index file is curr-
ently open, the path entry field contains the current directory
as default value, the file name and key expression fields are
empty, the unique attribute's default value is N (not unique).

    File Name: If NO extension is specified, the Default Index
File Extension as specified in the GlobalSet Pulldown menu will
be appended.

    Index key expression: The <F4> key can be pressed while on
the key expression entry field, to display a picklist of fields
from the current database. The key expression is validated,
invalid entry is recognized and rejected.
/23 Create Index File (5.01 & Six driver, 5.2 all drivers)
    This window can be accessed from the Index Main Menu opt-
ion, from the Index File Selection Screen by pressing <Alt-M>,
or from the Tag Info/Selection window by pressing <Ins>.
It is recommended that the current database be opened in
EXCLUSIVE mode for creation of an index file or tag.

    If an index file is marked as controlling index in the
right window of the Index File Selection Screen, this file's
path, name, compact or non-compact status, compound or non-
compound status, tag name, key expression, FOR conditional
expression, unique, ascending / descending and RYO attribute
are redisplayed in the window.

    If no index file is marked as controlling index, the path
entry field contains the current directory as default value,
the file name, tag name, key and conditional expression fields
are empty, the non-compact status, the compound status, the
unique, descending and RYO attribute's default values are all
"N" ("No").

    File Name: If NO extension is specified, the default index
file extension as specified in the GlobalSet option "Default
index extension" will be added.

    Key and conditional expression: The <F4> key can be pressed
from these entry fields, to display a picklist of fields from
the current database. The key or conditional expression is
validated, invalid entry is recognized and rejected.

    Other index creation options:

SCOPE: The default scope is ALL records. Optionally specify
       NEXT <n>, RECORD <n>, or REST.

WHILE: Optionally specify a WHILE condition, to only include
       records in the index while the condition is met, e.g.
       "SALARY = 10000"

EMPTY or "Roll Your Own" (RYO) index: Optionally create an
      index without any records, to allow adding/removing of
      individual records later on.

SUB-INDEX: Create the new index off the currently controlling
      index by keeping the order, condition, and scoping of the
      controlling index active during index creation.

NON-COMPACT: By default BroPlus creates compact index files. To
      create non-compact .IDX index files as used by Foxbase+,
      specify "Y" for this option.

Note: SCOPE, WHILE condition, and SUB-INDEX can only be used
      for temporary index creation. The attributes of those
      clauses are not maintained during database updating or
      reindexing.

Note: If a RYO index is contained as a tag of a compound (.CDX)
      index, it will be empty again after issuing a REINDEX.
      A non-compound (.IDX) index created as RYO index is NOT
      reorganized by REINDEX.
/24 Database Driver
    The Database Driver for a BroPlus session can be specified
in GlobalSet Pulldown menu option "Database Driver".
Available drivers are currently:

        DBFNTX for Clipper's NTX index files
        DBFNDX for dBase III NDX index files
        DBFMDX for dBASE IV  MDX index files
        DBFCDX for FoxPro IDX/CDX, FPT files
        DBFCMX for Comix driver by Loadstone
        DBFNSX for HiPerSIx index driver by SuccessWare
        SIXCDX for SuccessWare's SIx driver - CDX/FPT flavor
        SIXNSX for SuccessWare's SIx driver - NSX/SMT flavor

Any database opened with a specific Database Driver in place
will be using this Database Driver until closed.

    For the database to use a different Database Driver, close
the database (F2), select in the Database Driver Picklist (F6)
the desired Driver, and reopen the database (Alt-F2).

    The first item in the Pulldown Menu choices of the Database
Main Menu option, "Controlling Driver", shows which Database
Driver the current database is using. The controlling driver is
also displayed in the lower right corner of the Multi-Select
screens.
/25 Database Options
    The following Pulldown Menu options are displayed or selec-
table:
    - Selected: Ordinal number of the selected database, total
      number of open databases, and name of the selected data-
      base are displayed.

    - Controlling Driver: Shows which Database Driver the curr-
      ent database is using, including the type of memo.
      For the database to use a different Database Driver,
      close the database, toggle the GlobalSet Menu Option
      "Database Driver" to the desired Driver, then reopen the
      database.

    - Database Selection Screen: Multi-Select Interface for
      opening, selecting, and closing databases.

    - Next/Previous Database: Select the Next or Previous Data-
      base according to it's ordinal number as displayed in the
      first item of this Pulldown menu.

    - Close Database: Close the currently selected Database,
      and select the Next Open Database.

    - Open Mode: Toggle the Open Mode of the current database
      between SHARED and EXCLUSIVE. For global file modifica-
      tions, a database MUST be open in EXCLUSIVE mode.

    - Alias Name: Name the currently selected database needs
      to be referred by if used in expressions. Modifiable.

    - Create/Modify Structure: View/Create/Modify/Print data-
      base structure. Hot-key from Database Selection Screen:
      <Alt-M>.

    - Database FileSpec: Specify a FileSpec to be used for
      selection of databases in the Database Selection Screen.
      The FileSpec can contain the wildcard characters * and ?

    - Change Directory: Change to a specified drive/directory.
      Optionally choose from a Picklist of directories on a
      specified drive.

    - Shell to DOS: Shell out to DOS. To return to BroPlus type
      EXIT on the DOS Prompt.
/26 Database Selection
    The Database Selection Screen allows selection of up to
seven database files to work with. Database files available
for selection are displayed in the left window, selected
files are displayed in the right window. Files from the curr-
ent directory are displayed without path, files from other
directories are displayed including path.

    The current directory path is always displayed on row 3
left. All files in the current directory with the specified
file extension or FileSpec are displayed in the left window.

    In the right window, the "current" or "foreground" database
is marked by markers on both sides, which means: the Browse
Screen that belongs to this database is the current foreground
Browse Screen.

    <Enter> - adds the currently highlighted file in the left
window to the right window and marks it as foreground database.
If the file is already open in the right window but not marked,
<Enter> re-marks it as foreground database. If the file is
already marked as foreground database, <Enter> proceeds to the
Browse Window that belongs to this database.

    <Del> - scans the list of open databases in the right win-
dow for a file of the same name as the currently highlighted
file in the left window. If found, the selected file is closed
and removed from the right window. If the deleted file was
marked as foreground database, another file needs now to be
marked as foreground database using the <Enter> key.

    <Ins> - allows to add a file from another directory or
with an extension other than the default extension to the left
window of available databases. The added file is inserted at
the top of the picklist in the left window.

    <Esc> - clears the Database Selection Screen and displays
the Browse Window belonging to the foreground database. If
files are open but none is marked as foreground database,
<Esc> has no effect. If no database is opened and the right
window is empty, <Esc> allows to exit BroPlus.

    <F2> to <F9> - access Main Menu options.

    <Alt-F3> or <right> - clear the Database Selection Screen
and proceed to the Index File Selection Screen.

    <Alt-F4> - clear the Database Selection Screen and proceed
to the Fields Selection Screen.

    <Tab> or <Alt-N> - moves the marker for the foreground
database to the next file down in the right window. If the
marker is on the bottom file, <Tab> or <Alt-N> moves it back
to the top database.

    <Shift-Tab> or <Alt-Minus> - moves the marker for the fore-
ground database one file up (backwards) in the right window. If
the marker is on the top file, <Shift-Tab> moves it down to the
bottom file.

    <Alt-H> - display a listing of keystrokes available from
the Database Selection Screen.

    <Alt-F> - specify a Custom FileSpec for selection of data-
bases in the left window of the Database Selection Screen.

    <Alt-K> - close all currently open databases and remove
them from the right window.

    <Alt-M> - proceed to the "Modify/Create Database Struc-
ture" screen. If a file is marked as foreground database in
the right window, this file's structure is displayed. If the
right window is empty or no file is marked as foreground
database, <Alt-M> displays an empty structure screen.

    <Alt-X> - toggle the Open Mode of the foreground database
between SHARED and EXCLUSIVE. The current mode is shown to
the right on line 3.

    <Alt-Y> - allows changing from one directory to another
directory. After the change to the new directory, the right
window will contain the same selected files as before. The left
window will display currently open files on top, followed by
all files with the default extension or FileSpec in the new
directory.

    <Alt-Z> - shell out to DOS. To return to the Database
Selection Screen, type EXIT on the DOS Prompt.

    <Character> - AutoSeek. The Highlight Bar in the left
window moves to the desired item as you type. The characters
entered are displayed midscreen on line 4. To clear the Seek
String, press <Ctrl-Backspace>.
/27 Date Format
    Select your country-specific Date Format from the choices
offered in the Date Format picklist. Seven standard formats
without century digits are offered, each is replicated to in-
clude the century digits.

    If you choose a format that includes the century digits,
all Date display columns and Date entry fields are automati-
cally set to a width of 10.
/28 Default Directories
    Default Data File Directory: If a path is specified in this
entry field, BroPlus automatically changes to this directory
at startup, and returns to the original directory at end of
session. If no path is specified, BroPlus remains at startup
in the current directory.

    Default View File Directory: View files can be saved to /
restored from any directory. To better organize your View files
you may specify a Default View Directory where View files will
be saved to / restored from.
    If a view is restored from the Command Line, and NO path
is specified with the view file name, the Default View Direc-
tory will be searched for a matching view file name.
/29 Default File Extensions
    The GlobalSet Pulldown menu contains options to specify a
Default Database Extension, and a Default Index Extension. If
saved to Global Settings, these extensions are appended to
database and index names specified on the BroPlus command line.
They are also used for initial Database and Index FileSpec
settings in the File Selection Screens, and are appended to the
file name in the database and index creation windows if no ex-
tension is specified for the file to be created.

    SIx Driver memo extension permits use of an extension other
than .FPT for FPT memo files, or .SMT for SIXNSX memo files.

    FlexFile memo extension permits use of an extension other
than .DBV for FlexFile memos.

    Specify the non-default memo extension before opening the
database linked to the memo file with the non-default
extension.

    If the option to include 'Hidden' files is selected, the
Database- and Index Selection Screens will include files in the
picklist that were given the DOS-Attribute 'Hidden'.
/30 Delete Globally
    DELETE is a Pulldown Menu item on the "Command" Main Menu
option. It allows to Mark all records of the current database
for DELETION for/while a condition/range. It is recommended but
not mandatory to open the database EXCLUSIVE for DELETE to be
available.

Parameter entry fields:

    - SCOPE:  Press <Enter> to select between "ALL", "NEXT",
              and "REST", or press <Down arrow> to confirm the
              current scope. 
              If "ALL" (default) is chosen processing starts at
              top of file unless a "WHILE" expression is ent-
              ered.
              If "NEXT" or "REST" is chosen, or "ALL" with a
              "WHILE" expression, processing starts at the
              current record.
              If "NEXT" is selected, enter the number of re-
              cords to process starting at the current record.
              If "REST" is selected, all records from the cur-
              rent record until end of file are processed.
    - WHILE:  A "WHILE" clause usually requires an index to be
              in control. Enter a logical expression, and pro-
              cessing will continue as long as the expression
              evaluates to TRUE. Example: "AGE < 65".
              If a Range is specified for the current Browse
              Window, the beginning and ending values of the
              Range are automatically translated into a "WHILE"
              expression and offered as default.
    - FOR:    Enter a conditional expression, e.g.:
              ZIP = "90064". Only records meeting the "FOR"
              condition are included in the processing.
              If a Filter condition is specified for the cur-
              rent Browse Window, the Filter expression is
              automatically offered as default for the "FOR"
              condition.

FOR and WHILE clauses: The <F4> key can be pressed while on
    the entry field, to display a picklist of fields from the
    current database. The expression is validated, invalid
    entry is recognized and rejected.
/31 Delete / Recall
    The Delete / Recall Record option can be accessed from the
Record Main Menu option, or from the Browse Screen by pressing
<Del>.
    This option allows to Mark the currently highlighted record
in the Browse Window for deletion. If the record is deleted the
Deletion Mark can be removed by selecting this option again
(Recall).
    If the Pulldown Menu choice "PACK" from the "Command" Main
Menu option is selected, all records marked for deletion are
physically removed from the database and can no longer be re-
trieved or "recalled".
/32 Enable / Disable Modify
    In the GlobalSet Menu options, you can specify whether to
ENABLE or to DISABLE the Data Modification options of BroPlus.
    Depending on the way BroPlus was installed entry of a pass-
word may be required to toggle Modify to "ENABLED".
    If Modify is DISABLED, databases will always be opened in
SHARED mode, and EXCLUSIVE mode is NOT accessible. Also, for
security reasons and to provide Database System Integrity, none
of the Data Modification options of BroPlus are available.
    However, all other options of BroPlus remain accessible:
Database Selection, Index Selection, Field/Expression Selec-
tion, Saving/Restoring of views, and all viewing and printing
options are still available.
/33 Exit
    You may exit BroPlus by:

    - selecting the "Exit" Main Menu option by pressing <F9>
      from within the Browse Window, from any Main Menu option,
      from any Multi-Select Screen, pressing -> from the
      Command Main Menu option, or pressing <- from the Help
      Main Menu Option.

    - pressing <Esc> from within the Browse Window           

    - selecting "Exit" from the Database Pulldown Menu or
      pressing <Esc> from the Database Selection Screen if no
      databases are selected.
/00 end of help text broplus1.hlp
